SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This stunning residence perfectly blends sophistication and convenience, located just moments from Eastmans South Cove Activity Center. The residence combines comfort and style to create the ultimate retreat situated on over 2 private acres. The spacious living area features hardwood floors, cozy fireplace, soaring ceiling and large windows that flood the space with natural light. Enjoy a book or your morning coffee in the three season porch area offering views of the backyard oasis. The main level also features a beautiful chef's kitchen with custom cabinetry that flows to the dining area with another fireplace. Highlights of this home also boasts a library, den, morning bar area, large laundry room and first floor primary bedroom with a spacious bathroom. The upper level features another primary bedroom with a generous bathroom, guest bedroom en suite and a crafts room. Outside you will find above the two car detached garage a in-law suite or additional guest space with a bedroom, kitchen and a living area. Another two car garage area also has a beautiful spacious office or recreation area. This exceptional property is not to be missed.
Description:2 WOODS END ROAD- Well maintained 3-bed & 4-bath contemporary sited on 3 landscaped acres conveniently located just 10 minutes from downtown Hanover. A spacious and updated kitchen flows effortlessly into an open concept living & dining area with fireplace and wood stove and an expansive outdoor deck and gazebo, all of which bathes in natural light to make it a perfect setup for entertaining family and friends. On the front side of the house is another sizable living or family area, office space that is a ground floor bedroom option, and 3/4 bath. The second floor features a warm and sunlit primary suite, two additional bedrooms, and a full bath. A finished lower level complete with full bath and two versatile recreation / bonus rooms offers plenty of overflow space. Renovated mudroom on main level is dog kennel option. With easy access to area schools, recreation, restaurants, shopping, and more, this turnkey Hanover home is a must-see. Most of furnished photos are virtually staged.
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.
Description:A classic Cape Cod, post and beam New England home, in one of the premiere and most desirable Hanover neighborhoods. Sited on 5.05 private acres, this spacious and stylish home has a modern open concept floor plan, high ceilings with stunning woodwork, is flooded with natural light, and is just a short commute to Dartmouth College and Dartmouth Health. Significant additions have taken place, including the large piano room, and twin dormered bedrooms. The kitchen, with custom cabinetry and generous prep space, is perfect for intimate meals or lively gatherings that seamlessly flow into the adjoining dining and living rooms. The first floor also has an office, half bathroom and laundry room, as well as a functional breezeway/mudroom combination. Upstairs, the primary suite has an en-suite bathroom and walk-in closet. Three additional bedrooms are spacious and versatile, perfect for residents and guests and are supported by a 3/4 bathroom. The bonus room is a clever flexible space that could be an additional office, gym or studio. Outdoors, the stone patio overlooks a setting for relaxation and entertaining. Seller upgrades include: a ~10 year old roof, refinished floors and a repainted exterior, to name a few. With its prime location, refined interiors, and exceptional craftsmanship, this home invites you to experience the best of Hanover living. **Septic was designed as a 3 bedroom system. Open House on Saturday Jan 18th, from 9-11.
Description:This charming cape in downtown Hanover is a true gem! Recently expanded with a stunning new addition - featuring laundry room, large primary bedroom suite with amazing bathroom, built-ins and great closets. Two additional bedrooms upstairs with great storage and renovated bathroom. Living room with hardwood floors, kitchen opens to dining room making entertaining a breeze. Heated mudroom with french doors out to a large expanded deck. One car garage ready to be made into additional living space - office, workout room, or a craft room. With meticulous attention to detail throughout, this home blends classic charm with modern upgrades, creating the perfect space for comfortable living. Don’t miss the opportunity to own a piece of Hanover’s timeless appeal in an unbeatable location.